export const MachineQueries = {
    GetMachines: `
    SELECT
      id,
      machineName,
      machineContent,
      machinePhotoPath,
      machineOwnerId,
      machineOwnerName,
      machineOwnerPhone,
      machineOwnerEmail,
      machineStatus,
      createdTime
    FROM my_schema.machine
    `,

    GetActiveMachines: `
    SELECT
      id,
      machineName,
      machineContent,
      machinePhotoPath,
      machineOwnerId,
      machineOwnerName,
      machineOwnerPhone,
      machineOwnerEmail,
      machineStatus
    FROM my_schema.machine
    WHERE
      machineStatus = '可用'
    `,
  
    GetMachineById: `
    SELECT
      id,
      machineName,
      machineContent,
      machinePhotoPath,
      machineOwnerId,
      machineOwnerName,
      machineOwnerPhone,
      machineOwnerEmail,
      machineStatus
    FROM my_schema.machine
    WHERE
      id = ?
    `,
  
    AddMachine: `
    INSERT INTO my_schema.machine (machineName, machineContent, machinePhotoPath, machineOwnerId, machineOwnerName, machineOwnerPhone, machineOwnerEmail, machineStatus, createdTime, updatedTime)
      VALUES ?
    `,

    UpdateMachineById: `
    UPDATE my_schema.machine
    SET ?
    WHERE
      id = ?
    `,
  
    DeleteMachineById: `
    DELETE FROM my_schema.machine
    WHERE
      id = ?
    `
  };